Recommendation systems are a relatively new occurrence that have become a necessity when using modern day media platforms. One of the most famous examples of this is movie recommendations, present on a variety of video streaming services such as Netflix, Hulu and HBO. As students interested in data science and the applications thereof, as well as being avid consumers of movies ourselves, we would like to see how we could develop our own movie recommendation program. Prior to writing all the scripts/functions, we have cleaned and merged the raw data sets. The most recent versions are named movies_ratings_platforms.csv and movies_ratings_platforms_top1000.csv.
## $n_col
## [1] 24
##
## $col_names
## [1] "Movie" "Netflix"
## [3] "Hulu" "Prime.Video"
## [5] "Disney." "imdb_title_id"
## [7] "date_published" "genre"
## [9] "duration" "description"
## [11] "weighted_average_vote" "total_votes"
## [13] "mean_vote" "allgenders_0age_avg_vote"
## [15] "allgenders_0age_votes" "allgenders_18age_avg_vote"
## [17] "allgenders_18age_votes" "allgenders_30age_avg_vote"
## [19] "allgenders_30age_votes" "allgenders_45age_avg_vote"
## [21] "allgenders_45age_votes" "Certificate"
## [23] "Genre" "Meta_score"
##
## $n_rows
## [1] 207
##
## $n_movies
## [1] 169
##
## $mean_imdb
## [1] 7.565217
##
## $highest_imdb
## [1] 9
##
## $lowest_imdb
## [1] 2.4
##
## $mean_meta
## [1] 78.32367
##
## $top_4_certificates
## Certificate n
## 1 U 72
## 2 A 38
## 3 UA 34
## 4 R 24
We created a summary information function to compute useful information about our movie platform data sets. When run on our cleaned version; movies_ratings_platforms_top1000.csv data set, we find that the data set has 24 total columns, the titles of each being: Movie, Netflix, Hulu, Prime.Video, Disney., imdb_title_id, date_published, genre, duration, description, weighted_average_vote, total_votes, mean_vote, allgenders_0age_avg_vote, allgenders_0age_votes, allgenders_18age_avg_vote, allgenders_18age_votes, allgenders_30age_avg_vote, allgenders_30age_votes, allgenders_45age_avg_vote, allgenders_45age_votes, Certificate, Genre, Meta_score. The main columns we will use for analysis are weighted_average_vote and Meta_score. The average value for IMdb rating and meta score are 7.5652174 and 78.3236715, respectively. For 7.5652174, this is from a range of 9 (high) to 2.4 (low). The data set also consists of 207 movies, but as some movies are repeats, there are only actually 169 movies. Of the available movies, the most certificates are U, A, UA, R from most to least.
| Movie | Genre | weighted_average_vote | Metascore | duration | Netflix | Hulu | Prime.Video | Disney. |
|---|---|---|---|---|---|---|---|---|
| The Dark Knight | Action, Crime, Drama | 9.0 | 84 | 152 | No | Yes | No | No |
| Inception | Action, Adventure, Sci-Fi | 8.8 | 74 | 148 | Yes | No | No | No |
| The Matrix | Action, Sci-Fi | 8.7 | 73 | 136 | Yes | No | No | No |
| It’s a Wonderful Life | Drama, Family, Fantasy | 8.6 | 89 | 130 | No | No | Yes | No |
| The Green Mile | Crime, Drama, Fantasy | 8.6 | 61 | 189 | No | Yes | No | No |
| Back to the Future | Adventure, Comedy, Sci-Fi | 8.5 | 87 | 116 | Yes | No | No | No |
| Joker | Crime, Drama, Thriller | 8.5 | 59 | 122 | Yes | No | No | No |
| Psycho | Horror, Mystery, Thriller | 8.5 | 97 | 109 | Yes | No | No | No |
| The Lion King | Animation, Adventure, Drama | 8.5 | 88 | 88 | No | No | No | Yes |
| The Pianist | Biography, Drama, Music | 8.5 | 85 | 150 | Yes | No | Yes | No |
| 3 Idiots | Comedy, Drama | 8.4 | 67 | 170 | Yes | No | Yes | No |
| Avengers: Endgame | Action, Adventure, Drama | 8.4 | 78 | 181 | No | No | No | Yes |
| Avengers: Infinity War | Action, Adventure, Sci-Fi | 8.4 | 68 | 149 | Yes | No | No | No |
| Django Unchained | Drama, Western | 8.4 | 81 | 165 | Yes | No | No | No |
| Raiders of the Lost Ark | Action, Adventure | 8.4 | 85 | 115 | Yes | No | No | No |
| Spider-Man: Into the Spider-Verse | Animation, Action, Adventure | 8.4 | 87 | 117 | Yes | No | No | No |
| WALL·E | Animation, Adventure, Family | 8.4 | 95 | 98 | No | No | No | Yes |
| Good Will Hunting | Drama, Romance | 8.3 | 70 | 126 | No | Yes | No | No |
| Inglourious Basterds | Adventure, Drama, War | 8.3 | 69 | 153 | Yes | No | No | No |
| Taxi Driver | Crime, Drama | 8.3 | 94 | 114 | Yes | No | No | No |
| Toy Story | Animation, Adventure, Comedy | 8.3 | 95 | 81 | No | No | No | Yes |
| Toy Story 3 | Animation, Adventure, Comedy | 8.3 | 92 | 103 | No | No | No | Yes |
| Batman Begins | Action, Adventure | 8.2 | 70 | 140 | No | Yes | No | No |
| Chak De! India | Drama, Family, Sport | 8.2 | 68 | 153 | No | No | Yes | No |
| Indiana Jones and the Last Crusade | Action, Adventure | 8.2 | 65 | 127 | Yes | No | No | No |
| Klaus | Animation, Adventure, Comedy | 8.2 | 65 | 96 | Yes | No | No | No |
| Monty Python and the Holy Grail | Adventure, Comedy, Fantasy | 8.2 | 91 | 91 | Yes | No | No | No |
| There Will Be Blood | Drama | 8.2 | 93 | 158 | Yes | No | No | No |
| Up | Animation, Adventure, Comedy | 8.2 | 88 | 96 | No | No | No | Yes |
| Finding Nemo | Animation, Adventure, Comedy | 8.1 | 90 | 100 | No | No | No | Yes |
| Inherit the Wind | Biography, Drama, History | 8.1 | 75 | 128 | No | No | Yes | No |
| Inside Out | Animation, Adventure, Comedy | 8.1 | 94 | 95 | No | Yes | Yes | Yes |
| Kill Bill: Vol. 1 | Action, Crime, Thriller | 8.1 | 69 | 111 | No | Yes | No | No |
| Lagaan: Once Upon a Time in India | Adventure, Drama, Musical | 8.1 | 84 | 224 | Yes | No | No | No |
| Life of Brian | Comedy | 8.1 | 77 | 94 | Yes | No | No | No |
| Room | Drama, Thriller | 8.1 | 86 | 118 | Yes | No | No | No |
| Song of the Sea | Animation, Adventure, Drama | 8.1 | 85 | 93 | Yes | No | No | No |
| Sweet Smell of Success | Drama, Film-Noir | 8.1 | 100 | 96 | No | No | Yes | No |
| The Man Who Shot Liberty Valance | Drama, Western | 8.1 | 94 | 123 | No | No | Yes | No |
| The Princess Bride | Adventure, Family, Fantasy | 8.1 | 77 | 98 | No | No | No | Yes |
| What Ever Happened to Baby Jane? | Drama, Horror, Thriller | 8.1 | 75 | 134 | No | No | Yes | No |
| Aladdin | Animation, Adventure, Comedy | 8.0 | 86 | 90 | No | No | No | Yes |
| Brief Encounter | Drama, Romance | 8.0 | 92 | 86 | No | No | Yes | No |
| Dallas Buyers Club | Biography, Drama | 8.0 | 80 | 117 | Yes | No | No | No |
| Fiddler on the Roof | Drama, Family, Musical | 8.0 | 67 | 181 | No | No | Yes | No |
| Groundhog Day | Comedy, Fantasy, Romance | 8.0 | 72 | 101 | Yes | No | No | No |
| Guardians of the Galaxy | Action, Adventure, Comedy | 8.0 | 76 | 121 | No | No | No | Yes |
| Her | Drama, Romance, Sci-Fi | 8.0 | 90 | 126 | Yes | No | No | No |
| Kill Bill: Vol. 2 | Action, Crime, Thriller | 8.0 | 83 | 137 | No | Yes | No | No |
| Magnolia | Drama | 8.0 | 77 | 188 | Yes | No | No | No |
| Marriage Story | Comedy, Drama, Romance | 8.0 | 94 | 137 | Yes | No | No | No |
| Monsters, Inc. | Animation, Adventure, Comedy | 8.0 | 79 | 92 | No | No | No | Yes |
| Papillon | Biography, Crime, Drama | 8.0 | 58 | 151 | No | No | Yes | No |
| Pirates of the Caribbean: The Curse of the Black Pearl | Action, Adventure, Fantasy | 8.0 | 63 | 143 | No | No | No | Yes |
| Ratatouille | Animation, Adventure, Comedy | 8.0 | 96 | 111 | No | No | No | Yes |
| Roman Holiday | Comedy, Romance | 8.0 | 78 | 118 | No | No | Yes | No |
| Rosemary’s Baby | Drama, Horror | 8.0 | 96 | 137 | No | No | Yes | No |
| Short Term 12 | Drama | 8.0 | 82 | 96 | No | No | Yes | No |
| Sin City | Crime, Thriller | 8.0 | 74 | 124 | Yes | No | No | No |
| Stalag 17 | Comedy, Drama, War | 8.0 | 84 | 120 | No | No | Yes | No |
| The Avengers | Action, Adventure, Sci-Fi | 8.0 | 69 | 143 | No | No | Yes | Yes |
| The Graduate | Comedy, Drama, Romance | 8.0 | 83 | 106 | No | Yes | No | No |
| The Incredibles | Animation, Action, Adventure | 8.0 | 90 | 115 | No | No | No | Yes |
| The King’s Speech | Biography, Drama, History | 8.0 | 88 | 118 | Yes | No | No | No |
| The Nightmare Before Christmas | Animation, Family, Fantasy | 8.0 | 82 | 76 | No | No | No | Yes |
| The Perks of Being a Wallflower | Drama, Romance | 8.0 | 67 | 103 | Yes | No | No | No |
| The Pursuit of Happyness | Biography, Drama | 8.0 | 64 | 117 | Yes | No | No | No |
| The Sound of Music | Biography, Drama, Family | 8.0 | 63 | 172 | No | No | No | Yes |
| The Straight Story | Biography, Drama | 8.0 | 86 | 112 | No | No | No | Yes |
| Togo | Adventure, Biography, Drama | 8.0 | 69 | 113 | No | No | No | Yes |
| Zootopia | Animation, Adventure, Comedy | 8.0 | 78 | 108 | No | No | No | Yes |
| Captain Fantastic | Comedy, Drama | 7.9 | 72 | 118 | No | Yes | No | No |
| Charade | Comedy, Mystery, Romance | 7.9 | 83 | 113 | No | No | Yes | No |
| District 9 | Action, Sci-Fi, Thriller | 7.9 | 81 | 112 | Yes | No | No | No |
| Dunkirk | Action, Drama, History | 7.9 | 94 | 106 | No | No | Yes | No |
| Harold and Maude | Comedy, Drama, Romance | 7.9 | 62 | 91 | No | No | Yes | No |
| Hunt for the Wilderpeople | Adventure, Comedy, Drama | 7.9 | 81 | 101 | No | Yes | No | No |
| In the Heat of the Night | Crime, Drama, Mystery | 7.9 | 75 | 110 | No | No | Yes | No |
| Isle of Dogs | Animation, Adventure, Comedy | 7.9 | 82 | 101 | No | No | Yes | No |
| Moon | Drama, Mystery, Sci-Fi | 7.9 | 67 | 97 | Yes | No | No | No |
| Mystic River | Crime, Drama, Mystery | 7.9 | 84 | 138 | Yes | No | No | No |
| Night of the Living Dead | Horror, Thriller | 7.9 | 89 | 96 | No | No | Yes | No |
| The Artist | Comedy, Drama, Romance | 7.9 | 89 | 100 | Yes | No | No | No |
| The Irishman | Biography, Crime, Drama | 7.9 | 94 | 209 | Yes | No | No | No |
| Thor: Ragnarok | Action, Adventure, Comedy | 7.9 | 74 | 130 | No | No | No | Yes |
| Toy Story 2 | Animation, Adventure, Comedy | 7.9 | 88 | 92 | No | No | No | Yes |
| About Time | Comedy, Drama, Fantasy | 7.8 | 55 | 123 | Yes | No | No | No |
| Apocalypto | Action, Adventure, Drama | 7.8 | 68 | 139 | No | No | Yes | No |
| Avatar | Action, Adventure, Fantasy | 7.8 | 83 | 162 | No | No | No | Yes |
| Back to the Future Part II | Adventure, Comedy, Sci-Fi | 7.8 | 57 | 108 | Yes | No | No | No |
| Big Hero 6 | Animation, Action, Adventure | 7.8 | 74 | 102 | No | No | No | Yes |
| Captain America: Civil War | Action, Adventure, Sci-Fi | 7.8 | 75 | 147 | No | No | No | Yes |
| Fantasia | Animation, Family, Fantasy | 7.8 | 96 | 125 | No | No | No | Yes |
| Ferris Bueller’s Day Off | Comedy | 7.8 | 61 | 103 | Yes | No | No | No |
| Loving Vincent | Animation, Biography, Crime | 7.8 | 62 | 94 | No | Yes | No | No |
| Manchester by the Sea | Drama | 7.8 | 96 | 137 | No | No | Yes | No |
| Mary Poppins | Comedy, Family, Fantasy | 7.8 | 88 | 139 | No | No | No | Yes |
| Misery | Drama, Thriller | 7.8 | 75 | 107 | No | Yes | No | No |
| Mississippi Burning | Crime, Drama, History | 7.8 | 65 | 128 | No | No | Yes | No |
| Remember the Titans | Biography, Drama, Sport | 7.8 | 48 | 113 | No | No | No | Yes |
| The Boondock Saints | Action, Crime, Thriller | 7.8 | 44 | 108 | No | No | Yes | No |
| The Boy in the Striped Pyjamas | Drama, War | 7.8 | 55 | 94 | Yes | No | No | No |
| The Conversation | Drama, Mystery, Thriller | 7.8 | 85 | 113 | No | No | Yes | No |
| The Count of Monte Cristo | Action, Adventure, Drama | 7.8 | 61 | 131 | No | No | Yes | No |
| The Curious Case of Benjamin Button | Drama, Fantasy, Romance | 7.8 | 70 | 166 | Yes | No | No | No |
| The Fighter | Biography, Drama, Sport | 7.8 | 79 | 116 | No | No | Yes | No |
| The Girl with the Dragon Tattoo | Crime, Drama, Mystery | 7.8 | 71 | 158 | No | No | Yes | No |
| The Hateful Eight | Crime, Drama, Mystery | 7.8 | 68 | 168 | Yes | No | No | No |
| The Lady Vanishes | Mystery, Thriller | 7.8 | 98 | 96 | No | No | Yes | No |
| Toy Story 4 | Animation, Adventure, Comedy | 7.8 | 84 | 100 | No | No | No | Yes |
| Veer-Zaara | Drama, Family, Musical | 7.8 | 67 | 192 | No | No | Yes | No |
| What’s Eating Gilbert Grape | Drama | 7.8 | 73 | 118 | Yes | No | Yes | No |
| Willy Wonka & the Chocolate Factory | Family, Fantasy, Musical | 7.8 | 67 | 100 | Yes | No | No | No |
| Airplane! | Comedy | 7.7 | 78 | 88 | No | No | Yes | No |
| As Good as It Gets | Comedy, Drama, Romance | 7.7 | 67 | 139 | Yes | No | No | No |
| Beasts of No Nation | Drama, War | 7.7 | 79 | 137 | Yes | No | No | No |
| Blazing Saddles | Comedy, Western | 7.7 | 73 | 93 | No | Yes | No | No |
| Captain America: The Winter Soldier | Action, Adventure, Sci-Fi | 7.7 | 70 | 136 | No | No | No | Yes |
| Ex Machina | Drama, Sci-Fi, Thriller | 7.7 | 78 | 108 | Yes | No | No | No |
| Mission: Impossible - Fallout | Action, Adventure, Thriller | 7.7 | 86 | 147 | No | Yes | Yes | No |
| Ordinary People | Drama | 7.7 | 86 | 124 | No | No | Yes | No |
| Philadelphia | Drama | 7.7 | 66 | 125 | Yes | No | No | No |
| Road to Perdition | Crime, Drama, Thriller | 7.7 | 72 | 117 | Yes | No | No | No |
| Roma | Drama | 7.7 | 96 | 135 | Yes | No | No | No |
| Sabrina | Comedy, Drama, Romance | 7.7 | 72 | 113 | Yes | No | No | No |
| Shine | Biography, Drama, Music | 7.7 | 87 | 105 | No | No | Yes | No |
| Silver Linings Playbook | Comedy, Drama, Romance | 7.7 | 81 | 122 | Yes | No | No | No |
| Star Trek II: The Wrath of Khan | Action, Adventure, Sci-Fi | 7.7 | 67 | 113 | No | Yes | Yes | No |
| Tangled | Animation, Adventure, Comedy | 7.7 | 71 | 100 | No | No | No | Yes |
| The African Queen | Adventure, Drama, Romance | 7.7 | 91 | 105 | No | No | Yes | No |
| The Last of the Mohicans | Action, Adventure, Drama | 7.7 | 76 | 112 | No | No | Yes | No |
| The Last Samurai | Action, Drama, War | 7.7 | 55 | 154 | Yes | No | No | No |
| The Machinist | Drama, Thriller | 7.7 | 61 | 101 | No | No | Yes | No |
| The Muppet Christmas Carol | Comedy, Drama, Family | 7.7 | 64 | 85 | No | No | No | Yes |
| The Social Network | Biography, Drama | 7.7 | 95 | 120 | Yes | No | No | No |
| The Theory of Everything | Biography, Drama, Romance | 7.7 | 72 | 123 | Yes | No | No | No |
| Who Framed Roger Rabbit | Animation, Adventure, Comedy | 7.7 | 83 | 104 | No | No | No | Yes |
| Wreck-It Ralph | Animation, Adventure, Comedy | 7.7 | 72 | 101 | No | No | No | Yes |
| 50/50 | Comedy, Drama, Romance | 7.6 | 72 | 100 | No | Yes | No | No |
| Blow | Biography, Crime, Drama | 7.6 | 52 | 124 | Yes | No | No | No |
| Despicable Me | Animation, Comedy, Family | 7.6 | 72 | 95 | Yes | No | No | No |
| End of Watch | Action, Crime, Drama | 7.6 | 68 | 109 | Yes | No | No | No |
| Escape from Alcatraz | Action, Biography, Crime | 7.6 | 76 | 112 | No | Yes | Yes | No |
| Giant | Drama, Western | 7.6 | 84 | 201 | Yes | No | Yes | No |
| Guardians of the Galaxy Vol. 2 | Action, Adventure, Comedy | 7.6 | 67 | 136 | No | No | No | Yes |
| Hell or High Water | Action, Crime, Drama | 7.6 | 88 | 102 | Yes | No | No | No |
| Incredibles 2 | Animation, Action, Adventure | 7.6 | 80 | 118 | Yes | No | No | No |
| Minority Report | Action, Crime, Mystery | 7.6 | 80 | 145 | Yes | No | No | No |
| Moana | Animation, Adventure, Comedy | 7.6 | 81 | 107 | No | No | No | Yes |
| Mulan | Animation, Adventure, Family | 7.6 | 71 | 88 | No | No | No | Yes |
| Sicario | Action, Crime, Drama | 7.6 | 82 | 121 | No | No | Yes | No |
| The Florida Project | Drama | 7.6 | 92 | 111 | Yes | No | No | No |
| The Jungle Book | Animation, Adventure, Family | 7.6 | 65 | 78 | No | No | No | Yes |
| The Little Mermaid | Animation, Family, Fantasy | 7.6 | 88 | 83 | Yes | No | No | Yes |
| The Long Goodbye | Comedy, Crime, Drama | 7.6 | 87 | 112 | No | No | Yes | No |
| The Muppet Movie | Adventure, Comedy, Family | 7.6 | 74 | 95 | No | No | No | Yes |
| The Naked Gun: From the Files of Police Squad! | Comedy, Crime | 7.6 | 76 | 85 | Yes | No | No | No |
| Zombieland | Adventure, Comedy, Fantasy | 7.6 | 73 | 88 | No | Yes | Yes | No |
| True Grit | Adventure, Drama, Western | 7.4 | 80 | 128 | No | Yes | Yes | No |
| Freaks | Drama, Mystery, Sci-Fi | 6.7 | 80 | 105 | Yes | No | No | No |
| Some Like It Hot | Comedy, Musical, Romance | 6.7 | 98 | 65 | No | No | Yes | No |
| Miracle on 34th Street | Family, Fantasy | 6.5 | 88 | 114 | No | No | No | Yes |
| A Star Is Born | Drama, Music, Romance | 6.2 | 88 | 139 | No | No | Yes | No |
| Dark Waters | Drama, Horror, Mystery | 6.1 | 73 | 94 | No | No | Yes | No |
| Pride | Drama, Sport | 6.1 | 79 | 104 | No | No | Yes | No |
| Naked | Comedy, Fantasy, Romance | 5.4 | 84 | 96 | Yes | No | No | No |
| Serenity | Drama, Mystery, Thriller | 5.4 | 74 | 106 | No | No | Yes | No |
| Coco | Comedy, Drama | 3.3 | 81 | 95 | No | No | No | Yes |
| Drive | Action, Crime, Thriller | 3.0 | 78 | 147 | Yes | No | Yes | No |
This table summarizes the information of each movie, such as the movie name, the genre, weighted average vote, metascore, duration, and whether the movie is on each platform(Netflix, Hulu, Prime Video, and Disney).
This pie chart shows the popularity of each genre based on the movies that are rated above 7.0. The result shows that among those movies that are rated 7.0 or higher, 43.3% are Drama, 24.9% are Comedy, 16.9% are Action, 13.4% are Romance, and 1.5% are Horror. The genre Drama is the most popular and Horror is the least popular among high-rated movies.
The numbers around the pie chart represent the number of movies in each genre.
This bar chart is used to express binary variables. In other words, to show whether a movie is “on” or “not on” a certain platform. Bar chart is good for this intention, because it allows users to quickly spot the difference in value. Below is an example bar char that checks on the movie A Christmas Prince.
The bar chart shows the platforms: Netflix, Disney., Hulu, Prime.Video and illustrate whether a certain movie is on or not on those platform.
This plot chart attempts to express the most popular movies available on every streaming platform. This expresses the types of streaming service data that we have access to, and demonstrates the capability of sorting the overall data frame for specific values as well as combining them afterwords. Scatter plots were used for this display because of the many data points specific numerical values, and multiple categories (platforms).
The scatter plot displays the top 5 movies from every streaming service. The points contain the name and rating of the movie (when hovered), and are color coded by streaming service. The y values are the movie ratings.